using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VMKAP
    {
        public DataRow Convert2MKAP(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryMKAP(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["MKPMANDANT"] = " ".PadRight(2 ); 
         dwReturn["MKPPKSTKRS"] = " ".PadRight(2 ); 
         dwReturn["MKPPKST"] = " ".PadRight(4 ); 
         dwReturn["MKPKART"] = " ".PadRight(1 ); 
         dwReturn["MKPMTYP"] = " ".PadRight(8 ); 
         dwReturn["MKPANZABT"] = " ".PadRight(2 ); 
         dwReturn["MKPNRKRS"] = " ".PadRight(2 ); 
         dwReturn["MKPLFDNR"] = " ".PadRight(4 ); 
         dwReturn["MKPPOS"] = " ".PadRight(2 ); 
         dwReturn["MKPQUA"] = " ".PadRight(6 ); 
         dwReturn["MKPJJJJ"] = " ".PadRight(0 ); 
         dwReturn["MKPMM"] = " ".PadRight(0 ); 
         dwReturn["MKPAENDZL"] = " ".PadRight(0 ); 
         dwReturn["MKPBSG"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM1"] = " ".PadRight(0 ); 
         dwReturn["MKPPK1"] = " ".PadRight(0 ); 
         dwReturn["MKPDI1"] = " ".PadRight(0 ); 
         dwReturn["MKPTR1"] = " ".PadRight(0 ); 
         dwReturn["MKPFR1"] = " ".PadRight(0 ); 
         dwReturn["MKPRU1"] = " ".PadRight(0 ); 
         dwReturn["MKPSK1"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM2"] = " ".PadRight(0 ); 
         dwReturn["MKPPK2"] = " ".PadRight(0 ); 
         dwReturn["MKPDI2"] = " ".PadRight(0 ); 
         dwReturn["MKPTR2"] = " ".PadRight(0 ); 
         dwReturn["MKPFR2"] = " ".PadRight(0 ); 
         dwReturn["MKPRU2"] = " ".PadRight(0 ); 
         dwReturn["MKPSK2"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM3"] = " ".PadRight(0 ); 
         dwReturn["MKPPK3"] = " ".PadRight(0 ); 
         dwReturn["MKPDI3"] = " ".PadRight(0 ); 
         dwReturn["MKPTR3"] = " ".PadRight(0 ); 
         dwReturn["MKPFR3"] = " ".PadRight(0 ); 
         dwReturn["MKPRU3"] = " ".PadRight(0 ); 
         dwReturn["MKPSK3"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM4"] = " ".PadRight(0 ); 
         dwReturn["MKPPK4"] = " ".PadRight(0 ); 
         dwReturn["MKPDI4"] = " ".PadRight(0 ); 
         dwReturn["MKPTR4"] = " ".PadRight(0 ); 
         dwReturn["MKPFR4"] = " ".PadRight(0 ); 
         dwReturn["MKPRU4"] = " ".PadRight(0 ); 
         dwReturn["MKPSK4"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM5"] = " ".PadRight(0 ); 
         dwReturn["MKPPK5"] = " ".PadRight(0 ); 
         dwReturn["MKPDI5"] = " ".PadRight(0 ); 
         dwReturn["MKPTR5"] = " ".PadRight(0 ); 
         dwReturn["MKPFR5"] = " ".PadRight(0 ); 
         dwReturn["MKPRU5"] = " ".PadRight(0 ); 
         dwReturn["MKPSK5"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM6"] = " ".PadRight(0 ); 
         dwReturn["MKPPK6"] = " ".PadRight(0 ); 
         dwReturn["MKPDI6"] = " ".PadRight(0 ); 
         dwReturn["MKPTR6"] = " ".PadRight(0 ); 
         dwReturn["MKPFR6"] = " ".PadRight(0 ); 
         dwReturn["MKPRU6"] = " ".PadRight(0 ); 
         dwReturn["MKPSK6"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM7"] = " ".PadRight(0 ); 
         dwReturn["MKPPK7"] = " ".PadRight(0 ); 
         dwReturn["MKPDI7"] = " ".PadRight(0 ); 
         dwReturn["MKPTR7"] = " ".PadRight(0 ); 
         dwReturn["MKPFR7"] = " ".PadRight(0 ); 
         dwReturn["MKPRU7"] = " ".PadRight(0 ); 
         dwReturn["MKPSK7"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM8"] = " ".PadRight(0 ); 
         dwReturn["MKPPK8"] = " ".PadRight(0 ); 
         dwReturn["MKPDI8"] = " ".PadRight(0 ); 
         dwReturn["MKPTR8"] = " ".PadRight(0 ); 
         dwReturn["MKPFR8"] = " ".PadRight(0 ); 
         dwReturn["MKPRU8"] = " ".PadRight(0 ); 
         dwReturn["MKPSK8"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM9"] = " ".PadRight(0 ); 
         dwReturn["MKPPK9"] = " ".PadRight(0 ); 
         dwReturn["MKPDI9"] = " ".PadRight(0 ); 
         dwReturn["MKPTR9"] = " ".PadRight(0 ); 
         dwReturn["MKPFR9"] = " ".PadRight(0 ); 
         dwReturn["MKPRU9"] = " ".PadRight(0 ); 
         dwReturn["MKPSK9"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM10"] = " ".PadRight(0 ); 
         dwReturn["MKPPK10"] = " ".PadRight(0 ); 
         dwReturn["MKPDI10"] = " ".PadRight(0 ); 
         dwReturn["MKPTR10"] = " ".PadRight(0 ); 
         dwReturn["MKPFR10"] = " ".PadRight(0 ); 
         dwReturn["MKPRU10"] = " ".PadRight(0 ); 
         dwReturn["MKPSK10"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM11"] = " ".PadRight(0 ); 
         dwReturn["MKPPK11"] = " ".PadRight(0 ); 
         dwReturn["MKPDI11"] = " ".PadRight(0 ); 
         dwReturn["MKPTR11"] = " ".PadRight(0 ); 
         dwReturn["MKPFR11"] = " ".PadRight(0 ); 
         dwReturn["MKPRU11"] = " ".PadRight(0 ); 
         dwReturn["MKPSK11"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM12"] = " ".PadRight(0 ); 
         dwReturn["MKPPK12"] = " ".PadRight(0 ); 
         dwReturn["MKPDI12"] = " ".PadRight(0 ); 
         dwReturn["MKPTR12"] = " ".PadRight(0 ); 
         dwReturn["MKPFR12"] = " ".PadRight(0 ); 
         dwReturn["MKPRU12"] = " ".PadRight(0 ); 
         dwReturn["MKPSK12"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM13"] = " ".PadRight(0 ); 
         dwReturn["MKPPK13"] = " ".PadRight(0 ); 
         dwReturn["MKPDI13"] = " ".PadRight(0 ); 
         dwReturn["MKPTR13"] = " ".PadRight(0 ); 
         dwReturn["MKPFR13"] = " ".PadRight(0 ); 
         dwReturn["MKPRU13"] = " ".PadRight(0 ); 
         dwReturn["MKPSK13"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM14"] = " ".PadRight(0 ); 
         dwReturn["MKPPK14"] = " ".PadRight(0 ); 
         dwReturn["MKPDI14"] = " ".PadRight(0 ); 
         dwReturn["MKPTR14"] = " ".PadRight(0 ); 
         dwReturn["MKPFR14"] = " ".PadRight(0 ); 
         dwReturn["MKPRU14"] = " ".PadRight(0 ); 
         dwReturn["MKPSK14"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM15"] = " ".PadRight(0 ); 
         dwReturn["MKPPK15"] = " ".PadRight(0 ); 
         dwReturn["MKPDI15"] = " ".PadRight(0 ); 
         dwReturn["MKPTR15"] = " ".PadRight(0 ); 
         dwReturn["MKPFR15"] = " ".PadRight(0 ); 
         dwReturn["MKPRU15"] = " ".PadRight(0 ); 
         dwReturn["MKPSK15"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM16"] = " ".PadRight(0 ); 
         dwReturn["MKPPK16"] = " ".PadRight(0 ); 
         dwReturn["MKPDI16"] = " ".PadRight(0 ); 
         dwReturn["MKPTR16"] = " ".PadRight(0 ); 
         dwReturn["MKPFR16"] = " ".PadRight(0 ); 
         dwReturn["MKPRU16"] = " ".PadRight(0 ); 
         dwReturn["MKPSK16"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM17"] = " ".PadRight(0 ); 
         dwReturn["MKPPK17"] = " ".PadRight(0 ); 
         dwReturn["MKPDI17"] = " ".PadRight(0 ); 
         dwReturn["MKPTR17"] = " ".PadRight(0 ); 
         dwReturn["MKPFR17"] = " ".PadRight(0 ); 
         dwReturn["MKPRU17"] = " ".PadRight(0 ); 
         dwReturn["MKPSK17"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM18"] = " ".PadRight(0 ); 
         dwReturn["MKPPK18"] = " ".PadRight(0 ); 
         dwReturn["MKPDI18"] = " ".PadRight(0 ); 
         dwReturn["MKPTR18"] = " ".PadRight(0 ); 
         dwReturn["MKPFR18"] = " ".PadRight(0 ); 
         dwReturn["MKPRU18"] = " ".PadRight(0 ); 
         dwReturn["MKPSK18"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM19"] = " ".PadRight(0 ); 
         dwReturn["MKPPK19"] = " ".PadRight(0 ); 
         dwReturn["MKPDI19"] = " ".PadRight(0 ); 
         dwReturn["MKPTR19"] = " ".PadRight(0 ); 
         dwReturn["MKPFR19"] = " ".PadRight(0 ); 
         dwReturn["MKPRU19"] = " ".PadRight(0 ); 
         dwReturn["MKPSK19"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM20"] = " ".PadRight(0 ); 
         dwReturn["MKPPK20"] = " ".PadRight(0 ); 
         dwReturn["MKPDI20"] = " ".PadRight(0 ); 
         dwReturn["MKPTR20"] = " ".PadRight(0 ); 
         dwReturn["MKPFR20"] = " ".PadRight(0 ); 
         dwReturn["MKPRU20"] = " ".PadRight(0 ); 
         dwReturn["MKPSK20"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM21"] = " ".PadRight(0 ); 
         dwReturn["MKPPK21"] = " ".PadRight(0 ); 
         dwReturn["MKPDI21"] = " ".PadRight(0 ); 
         dwReturn["MKPTR21"] = " ".PadRight(0 ); 
         dwReturn["MKPFR21"] = " ".PadRight(0 ); 
         dwReturn["MKPRU21"] = " ".PadRight(0 ); 
         dwReturn["MKPSK21"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM22"] = " ".PadRight(0 ); 
         dwReturn["MKPPK22"] = " ".PadRight(0 ); 
         dwReturn["MKPDI22"] = " ".PadRight(0 ); 
         dwReturn["MKPTR22"] = " ".PadRight(0 ); 
         dwReturn["MKPFR22"] = " ".PadRight(0 ); 
         dwReturn["MKPRU22"] = " ".PadRight(0 ); 
         dwReturn["MKPSK22"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM23"] = " ".PadRight(0 ); 
         dwReturn["MKPPK23"] = " ".PadRight(0 ); 
         dwReturn["MKPDI23"] = " ".PadRight(0 ); 
         dwReturn["MKPTR23"] = " ".PadRight(0 ); 
         dwReturn["MKPFR23"] = " ".PadRight(0 ); 
         dwReturn["MKPRU23"] = " ".PadRight(0 ); 
         dwReturn["MKPSK23"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM24"] = " ".PadRight(0 ); 
         dwReturn["MKPPK24"] = " ".PadRight(0 ); 
         dwReturn["MKPDI24"] = " ".PadRight(0 ); 
         dwReturn["MKPTR24"] = " ".PadRight(0 ); 
         dwReturn["MKPFR24"] = " ".PadRight(0 ); 
         dwReturn["MKPRU24"] = " ".PadRight(0 ); 
         dwReturn["MKPSK24"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM25"] = " ".PadRight(0 ); 
         dwReturn["MKPPK25"] = " ".PadRight(0 ); 
         dwReturn["MKPDI25"] = " ".PadRight(0 ); 
         dwReturn["MKPTR25"] = " ".PadRight(0 ); 
         dwReturn["MKPFR25"] = " ".PadRight(0 ); 
         dwReturn["MKPRU25"] = " ".PadRight(0 ); 
         dwReturn["MKPSK25"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM26"] = " ".PadRight(0 ); 
         dwReturn["MKPPK26"] = " ".PadRight(0 ); 
         dwReturn["MKPDI26"] = " ".PadRight(0 ); 
         dwReturn["MKPTR26"] = " ".PadRight(0 ); 
         dwReturn["MKPFR26"] = " ".PadRight(0 ); 
         dwReturn["MKPRU26"] = " ".PadRight(0 ); 
         dwReturn["MKPSK26"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM27"] = " ".PadRight(0 ); 
         dwReturn["MKPPK27"] = " ".PadRight(0 ); 
         dwReturn["MKPDI27"] = " ".PadRight(0 ); 
         dwReturn["MKPTR27"] = " ".PadRight(0 ); 
         dwReturn["MKPFR27"] = " ".PadRight(0 ); 
         dwReturn["MKPRU27"] = " ".PadRight(0 ); 
         dwReturn["MKPSK27"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM28"] = " ".PadRight(0 ); 
         dwReturn["MKPPK28"] = " ".PadRight(0 ); 
         dwReturn["MKPDI28"] = " ".PadRight(0 ); 
         dwReturn["MKPTR28"] = " ".PadRight(0 ); 
         dwReturn["MKPFR28"] = " ".PadRight(0 ); 
         dwReturn["MKPRU28"] = " ".PadRight(0 ); 
         dwReturn["MKPSK28"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM29"] = " ".PadRight(0 ); 
         dwReturn["MKPPK29"] = " ".PadRight(0 ); 
         dwReturn["MKPDI29"] = " ".PadRight(0 ); 
         dwReturn["MKPTR29"] = " ".PadRight(0 ); 
         dwReturn["MKPFR29"] = " ".PadRight(0 ); 
         dwReturn["MKPRU29"] = " ".PadRight(0 ); 
         dwReturn["MKPSK29"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM30"] = " ".PadRight(0 ); 
         dwReturn["MKPPK30"] = " ".PadRight(0 ); 
         dwReturn["MKPDI30"] = " ".PadRight(0 ); 
         dwReturn["MKPTR30"] = " ".PadRight(0 ); 
         dwReturn["MKPFR30"] = " ".PadRight(0 ); 
         dwReturn["MKPRU30"] = " ".PadRight(0 ); 
         dwReturn["MKPSK30"] = " ".PadRight(0 ); 
         dwReturn["MKPANZM31"] = " ".PadRight(0 ); 
         dwReturn["MKPPK31"] = " ".PadRight(0 ); 
         dwReturn["MKPDI31"] = " ".PadRight(0 ); 
         dwReturn["MKPTR31"] = " ".PadRight(0 ); 
         dwReturn["MKPFR31"] = " ".PadRight(0 ); 
         dwReturn["MKPRU31"] = " ".PadRight(0 ); 
         dwReturn["MKPSK31"] = " ".PadRight(0 ); 
         dwReturn["MKPFAKTOR"] = " ".PadRight(12 ); 
         dwReturn["MKPANZTAG"] = " ".PadRight(0 ); 
         dwReturn["MKPFILLER"] = " ".PadRight(13 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapMKAP(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveMKAP(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryMKAP(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapMKAP(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertMKAP(dwLocal, ITXDBVERSION);
            }
            UpdateMKAP(dwLocal);
        }
        public void InsertMKAP(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO MKAP(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryMKAP(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM MKAP WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM MKAP  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "MKAP";
            Return = Result;
            return Return;
        }
        public void DeleteMKAP(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM MKAP   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateMKAP(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE MKAP SET "
                    +"MKPMANDANT= :MKPMANDANT,"
                    +"MKPPKSTKRS= :MKPPKSTKRS,"
                    +"MKPPKST= :MKPPKST,"
                    +"MKPKART= :MKPKART,"
                    +"MKPMTYP= :MKPMTYP,"
                    +"MKPANZABT= :MKPANZABT,"
                    +"MKPNRKRS= :MKPNRKRS,"
                    +"MKPLFDNR= :MKPLFDNR,"
                    +"MKPPOS= :MKPPOS,"
                    +"MKPQUA= :MKPQUA,"
                    +"MKPJJJJ= :MKPJJJJ,"
                    +"MKPMM= :MKPMM,"
                    +"MKPAENDZL= :MKPAENDZL,"
                    +"MKPBSG= :MKPBSG,"
                    +"MKPANZM1= :MKPANZM1,"
                    +"MKPPK1= :MKPPK1,"
                    +"MKPDI1= :MKPDI1,"
                    +"MKPTR1= :MKPTR1,"
                    +"MKPFR1= :MKPFR1,"
                    +"MKPRU1= :MKPRU1,"
                    +"MKPSK1= :MKPSK1,"
                    +"MKPANZM2= :MKPANZM2,"
                    +"MKPPK2= :MKPPK2,"
                    +"MKPDI2= :MKPDI2,"
                    +"MKPTR2= :MKPTR2,"
                    +"MKPFR2= :MKPFR2,"
                    +"MKPRU2= :MKPRU2,"
                    +"MKPSK2= :MKPSK2,"
                    +"MKPANZM3= :MKPANZM3,"
                    +"MKPPK3= :MKPPK3,"
                    +"MKPDI3= :MKPDI3,"
                    +"MKPTR3= :MKPTR3,"
                    +"MKPFR3= :MKPFR3,"
                    +"MKPRU3= :MKPRU3,"
                    +"MKPSK3= :MKPSK3,"
                    +"MKPANZM4= :MKPANZM4,"
                    +"MKPPK4= :MKPPK4,"
                    +"MKPDI4= :MKPDI4,"
                    +"MKPTR4= :MKPTR4,"
                    +"MKPFR4= :MKPFR4,"
                    +"MKPRU4= :MKPRU4,"
                    +"MKPSK4= :MKPSK4,"
                    +"MKPANZM5= :MKPANZM5,"
                    +"MKPPK5= :MKPPK5,"
                    +"MKPDI5= :MKPDI5,"
                    +"MKPTR5= :MKPTR5,"
                    +"MKPFR5= :MKPFR5,"
                    +"MKPRU5= :MKPRU5,"
                    +"MKPSK5= :MKPSK5,"
                    +"MKPANZM6= :MKPANZM6,"
                    +"MKPPK6= :MKPPK6,"
                    +"MKPDI6= :MKPDI6,"
                    +"MKPTR6= :MKPTR6,"
                    +"MKPFR6= :MKPFR6,"
                    +"MKPRU6= :MKPRU6,"
                    +"MKPSK6= :MKPSK6,"
                    +"MKPANZM7= :MKPANZM7,"
                    +"MKPPK7= :MKPPK7,"
                    +"MKPDI7= :MKPDI7,"
                    +"MKPTR7= :MKPTR7,"
                    +"MKPFR7= :MKPFR7,"
                    +"MKPRU7= :MKPRU7,"
                    +"MKPSK7= :MKPSK7,"
                    +"MKPANZM8= :MKPANZM8,"
                    +"MKPPK8= :MKPPK8,"
                    +"MKPDI8= :MKPDI8,"
                    +"MKPTR8= :MKPTR8,"
                    +"MKPFR8= :MKPFR8,"
                    +"MKPRU8= :MKPRU8,"
                    +"MKPSK8= :MKPSK8,"
                    +"MKPANZM9= :MKPANZM9,"
                    +"MKPPK9= :MKPPK9,"
                    +"MKPDI9= :MKPDI9,"
                    +"MKPTR9= :MKPTR9,"
                    +"MKPFR9= :MKPFR9,"
                    +"MKPRU9= :MKPRU9,"
                    +"MKPSK9= :MKPSK9,"
                    +"MKPANZM10= :MKPANZM10,"
                    +"MKPPK10= :MKPPK10,"
                    +"MKPDI10= :MKPDI10,"
                    +"MKPTR10= :MKPTR10,"
                    +"MKPFR10= :MKPFR10,"
                    +"MKPRU10= :MKPRU10,"
                    +"MKPSK10= :MKPSK10,"
                    +"MKPANZM11= :MKPANZM11,"
                    +"MKPPK11= :MKPPK11,"
                    +"MKPDI11= :MKPDI11,"
                    +"MKPTR11= :MKPTR11,"
                    +"MKPFR11= :MKPFR11,"
                    +"MKPRU11= :MKPRU11,"
                    +"MKPSK11= :MKPSK11,"
                    +"MKPANZM12= :MKPANZM12,"
                    +"MKPPK12= :MKPPK12,"
                    +"MKPDI12= :MKPDI12,"
                    +"MKPTR12= :MKPTR12,"
                    +"MKPFR12= :MKPFR12,"
                    +"MKPRU12= :MKPRU12,"
                    +"MKPSK12= :MKPSK12,"
                    +"MKPANZM13= :MKPANZM13,"
                    +"MKPPK13= :MKPPK13,"
                    +"MKPDI13= :MKPDI13,"
                    +"MKPTR13= :MKPTR13,"
                    +"MKPFR13= :MKPFR13,"
                    +"MKPRU13= :MKPRU13,"
                    +"MKPSK13= :MKPSK13,"
                    +"MKPANZM14= :MKPANZM14,"
                    +"MKPPK14= :MKPPK14,"
                    +"MKPDI14= :MKPDI14,"
                    +"MKPTR14= :MKPTR14,"
                    +"MKPFR14= :MKPFR14,"
                    +"MKPRU14= :MKPRU14,"
                    +"MKPSK14= :MKPSK14,"
                    +"MKPANZM15= :MKPANZM15,"
                    +"MKPPK15= :MKPPK15,"
                    +"MKPDI15= :MKPDI15,"
                    +"MKPTR15= :MKPTR15,"
                    +"MKPFR15= :MKPFR15,"
                    +"MKPRU15= :MKPRU15,"
                    +"MKPSK15= :MKPSK15,"
                    +"MKPANZM16= :MKPANZM16,"
                    +"MKPPK16= :MKPPK16,"
                    +"MKPDI16= :MKPDI16,"
                    +"MKPTR16= :MKPTR16,"
                    +"MKPFR16= :MKPFR16,"
                    +"MKPRU16= :MKPRU16,"
                    +"MKPSK16= :MKPSK16,"
                    +"MKPANZM17= :MKPANZM17,"
                    +"MKPPK17= :MKPPK17,"
                    +"MKPDI17= :MKPDI17,"
                    +"MKPTR17= :MKPTR17,"
                    +"MKPFR17= :MKPFR17,"
                    +"MKPRU17= :MKPRU17,"
                    +"MKPSK17= :MKPSK17,"
                    +"MKPANZM18= :MKPANZM18,"
                    +"MKPPK18= :MKPPK18,"
                    +"MKPDI18= :MKPDI18,"
                    +"MKPTR18= :MKPTR18,"
                    +"MKPFR18= :MKPFR18,"
                    +"MKPRU18= :MKPRU18,"
                    +"MKPSK18= :MKPSK18,"
                    +"MKPANZM19= :MKPANZM19,"
                    +"MKPPK19= :MKPPK19,"
                    +"MKPDI19= :MKPDI19,"
                    +"MKPTR19= :MKPTR19,"
                    +"MKPFR19= :MKPFR19,"
                    +"MKPRU19= :MKPRU19,"
                    +"MKPSK19= :MKPSK19,"
                    +"MKPANZM20= :MKPANZM20,"
                    +"MKPPK20= :MKPPK20,"
                    +"MKPDI20= :MKPDI20,"
                    +"MKPTR20= :MKPTR20,"
                    +"MKPFR20= :MKPFR20,"
                    +"MKPRU20= :MKPRU20,"
                    +"MKPSK20= :MKPSK20,"
                    +"MKPANZM21= :MKPANZM21,"
                    +"MKPPK21= :MKPPK21,"
                    +"MKPDI21= :MKPDI21,"
                    +"MKPTR21= :MKPTR21,"
                    +"MKPFR21= :MKPFR21,"
                    +"MKPRU21= :MKPRU21,"
                    +"MKPSK21= :MKPSK21,"
                    +"MKPANZM22= :MKPANZM22,"
                    +"MKPPK22= :MKPPK22,"
                    +"MKPDI22= :MKPDI22,"
                    +"MKPTR22= :MKPTR22,"
                    +"MKPFR22= :MKPFR22,"
                    +"MKPRU22= :MKPRU22,"
                    +"MKPSK22= :MKPSK22,"
                    +"MKPANZM23= :MKPANZM23,"
                    +"MKPPK23= :MKPPK23,"
                    +"MKPDI23= :MKPDI23,"
                    +"MKPTR23= :MKPTR23,"
                    +"MKPFR23= :MKPFR23,"
                    +"MKPRU23= :MKPRU23,"
                    +"MKPSK23= :MKPSK23,"
                    +"MKPANZM24= :MKPANZM24,"
                    +"MKPPK24= :MKPPK24,"
                    +"MKPDI24= :MKPDI24,"
                    +"MKPTR24= :MKPTR24,"
                    +"MKPFR24= :MKPFR24,"
                    +"MKPRU24= :MKPRU24,"
                    +"MKPSK24= :MKPSK24,"
                    +"MKPANZM25= :MKPANZM25,"
                    +"MKPPK25= :MKPPK25,"
                    +"MKPDI25= :MKPDI25,"
                    +"MKPTR25= :MKPTR25,"
                    +"MKPFR25= :MKPFR25,"
                    +"MKPRU25= :MKPRU25,"
                    +"MKPSK25= :MKPSK25,"
                    +"MKPANZM26= :MKPANZM26,"
                    +"MKPPK26= :MKPPK26,"
                    +"MKPDI26= :MKPDI26,"
                    +"MKPTR26= :MKPTR26,"
                    +"MKPFR26= :MKPFR26,"
                    +"MKPRU26= :MKPRU26,"
                    +"MKPSK26= :MKPSK26,"
                    +"MKPANZM27= :MKPANZM27,"
                    +"MKPPK27= :MKPPK27,"
                    +"MKPDI27= :MKPDI27,"
                    +"MKPTR27= :MKPTR27,"
                    +"MKPFR27= :MKPFR27,"
                    +"MKPRU27= :MKPRU27,"
                    +"MKPSK27= :MKPSK27,"
                    +"MKPANZM28= :MKPANZM28,"
                    +"MKPPK28= :MKPPK28,"
                    +"MKPDI28= :MKPDI28,"
                    +"MKPTR28= :MKPTR28,"
                    +"MKPFR28= :MKPFR28,"
                    +"MKPRU28= :MKPRU28,"
                    +"MKPSK28= :MKPSK28,"
                    +"MKPANZM29= :MKPANZM29,"
                    +"MKPPK29= :MKPPK29,"
                    +"MKPDI29= :MKPDI29,"
                    +"MKPTR29= :MKPTR29,"
                    +"MKPFR29= :MKPFR29,"
                    +"MKPRU29= :MKPRU29,"
                    +"MKPSK29= :MKPSK29,"
                    +"MKPANZM30= :MKPANZM30,"
                    +"MKPPK30= :MKPPK30,"
                    +"MKPDI30= :MKPDI30,"
                    +"MKPTR30= :MKPTR30,"
                    +"MKPFR30= :MKPFR30,"
                    +"MKPRU30= :MKPRU30,"
                    +"MKPSK30= :MKPSK30,"
                    +"MKPANZM31= :MKPANZM31,"
                    +"MKPPK31= :MKPPK31,"
                    +"MKPDI31= :MKPDI31,"
                    +"MKPTR31= :MKPTR31,"
                    +"MKPFR31= :MKPFR31,"
                    +"MKPRU31= :MKPRU31,"
                    +"MKPSK31= :MKPSK31,"
                    +"MKPFAKTOR= :MKPFAKTOR,"
                    +"MKPANZTAG= :MKPANZTAG,"
                    +"MKPFILLER= :MKPFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("MKPMANDANT", OracleType.NVarChar).Value = dwData["MKPMANDANT"].ToString(); 
          or1.Parameters.Add("MKPPKSTKRS", OracleType.NVarChar).Value = dwData["MKPPKSTKRS"].ToString(); 
          or1.Parameters.Add("MKPPKST", OracleType.NVarChar).Value = dwData["MKPPKST"].ToString(); 
          or1.Parameters.Add("MKPKART", OracleType.NVarChar).Value = dwData["MKPKART"].ToString(); 
          or1.Parameters.Add("MKPMTYP", OracleType.NVarChar).Value = dwData["MKPMTYP"].ToString(); 
          or1.Parameters.Add("MKPANZABT", OracleType.NVarChar).Value = dwData["MKPANZABT"].ToString(); 
          or1.Parameters.Add("MKPNRKRS", OracleType.NVarChar).Value = dwData["MKPNRKRS"].ToString(); 
          or1.Parameters.Add("MKPLFDNR", OracleType.NVarChar).Value = dwData["MKPLFDNR"].ToString(); 
          or1.Parameters.Add("MKPPOS", OracleType.NVarChar).Value = dwData["MKPPOS"].ToString(); 
          or1.Parameters.Add("MKPQUA", OracleType.NVarChar).Value = dwData["MKPQUA"].ToString(); 
          or1.Parameters.Add("MKPJJJJ", OracleType.NVarChar).Value = dwData["MKPJJJJ"].ToString(); 
          or1.Parameters.Add("MKPMM", OracleType.NVarChar).Value = dwData["MKPMM"].ToString(); 
          or1.Parameters.Add("MKPAENDZL", OracleType.NVarChar).Value = dwData["MKPAENDZL"].ToString(); 
          or1.Parameters.Add("MKPBSG", OracleType.NVarChar).Value = dwData["MKPBSG"].ToString(); 
          or1.Parameters.Add("MKPANZM1", OracleType.NVarChar).Value = dwData["MKPANZM1"].ToString(); 
          or1.Parameters.Add("MKPPK1", OracleType.NVarChar).Value = dwData["MKPPK1"].ToString(); 
          or1.Parameters.Add("MKPDI1", OracleType.NVarChar).Value = dwData["MKPDI1"].ToString(); 
          or1.Parameters.Add("MKPTR1", OracleType.NVarChar).Value = dwData["MKPTR1"].ToString(); 
          or1.Parameters.Add("MKPFR1", OracleType.NVarChar).Value = dwData["MKPFR1"].ToString(); 
          or1.Parameters.Add("MKPRU1", OracleType.NVarChar).Value = dwData["MKPRU1"].ToString(); 
          or1.Parameters.Add("MKPSK1", OracleType.NVarChar).Value = dwData["MKPSK1"].ToString(); 
          or1.Parameters.Add("MKPANZM2", OracleType.NVarChar).Value = dwData["MKPANZM2"].ToString(); 
          or1.Parameters.Add("MKPPK2", OracleType.NVarChar).Value = dwData["MKPPK2"].ToString(); 
          or1.Parameters.Add("MKPDI2", OracleType.NVarChar).Value = dwData["MKPDI2"].ToString(); 
          or1.Parameters.Add("MKPTR2", OracleType.NVarChar).Value = dwData["MKPTR2"].ToString(); 
          or1.Parameters.Add("MKPFR2", OracleType.NVarChar).Value = dwData["MKPFR2"].ToString(); 
          or1.Parameters.Add("MKPRU2", OracleType.NVarChar).Value = dwData["MKPRU2"].ToString(); 
          or1.Parameters.Add("MKPSK2", OracleType.NVarChar).Value = dwData["MKPSK2"].ToString(); 
          or1.Parameters.Add("MKPANZM3", OracleType.NVarChar).Value = dwData["MKPANZM3"].ToString(); 
          or1.Parameters.Add("MKPPK3", OracleType.NVarChar).Value = dwData["MKPPK3"].ToString(); 
          or1.Parameters.Add("MKPDI3", OracleType.NVarChar).Value = dwData["MKPDI3"].ToString(); 
          or1.Parameters.Add("MKPTR3", OracleType.NVarChar).Value = dwData["MKPTR3"].ToString(); 
          or1.Parameters.Add("MKPFR3", OracleType.NVarChar).Value = dwData["MKPFR3"].ToString(); 
          or1.Parameters.Add("MKPRU3", OracleType.NVarChar).Value = dwData["MKPRU3"].ToString(); 
          or1.Parameters.Add("MKPSK3", OracleType.NVarChar).Value = dwData["MKPSK3"].ToString(); 
          or1.Parameters.Add("MKPANZM4", OracleType.NVarChar).Value = dwData["MKPANZM4"].ToString(); 
          or1.Parameters.Add("MKPPK4", OracleType.NVarChar).Value = dwData["MKPPK4"].ToString(); 
          or1.Parameters.Add("MKPDI4", OracleType.NVarChar).Value = dwData["MKPDI4"].ToString(); 
          or1.Parameters.Add("MKPTR4", OracleType.NVarChar).Value = dwData["MKPTR4"].ToString(); 
          or1.Parameters.Add("MKPFR4", OracleType.NVarChar).Value = dwData["MKPFR4"].ToString(); 
          or1.Parameters.Add("MKPRU4", OracleType.NVarChar).Value = dwData["MKPRU4"].ToString(); 
          or1.Parameters.Add("MKPSK4", OracleType.NVarChar).Value = dwData["MKPSK4"].ToString(); 
          or1.Parameters.Add("MKPANZM5", OracleType.NVarChar).Value = dwData["MKPANZM5"].ToString(); 
          or1.Parameters.Add("MKPPK5", OracleType.NVarChar).Value = dwData["MKPPK5"].ToString(); 
          or1.Parameters.Add("MKPDI5", OracleType.NVarChar).Value = dwData["MKPDI5"].ToString(); 
          or1.Parameters.Add("MKPTR5", OracleType.NVarChar).Value = dwData["MKPTR5"].ToString(); 
          or1.Parameters.Add("MKPFR5", OracleType.NVarChar).Value = dwData["MKPFR5"].ToString(); 
          or1.Parameters.Add("MKPRU5", OracleType.NVarChar).Value = dwData["MKPRU5"].ToString(); 
          or1.Parameters.Add("MKPSK5", OracleType.NVarChar).Value = dwData["MKPSK5"].ToString(); 
          or1.Parameters.Add("MKPANZM6", OracleType.NVarChar).Value = dwData["MKPANZM6"].ToString(); 
          or1.Parameters.Add("MKPPK6", OracleType.NVarChar).Value = dwData["MKPPK6"].ToString(); 
          or1.Parameters.Add("MKPDI6", OracleType.NVarChar).Value = dwData["MKPDI6"].ToString(); 
          or1.Parameters.Add("MKPTR6", OracleType.NVarChar).Value = dwData["MKPTR6"].ToString(); 
          or1.Parameters.Add("MKPFR6", OracleType.NVarChar).Value = dwData["MKPFR6"].ToString(); 
          or1.Parameters.Add("MKPRU6", OracleType.NVarChar).Value = dwData["MKPRU6"].ToString(); 
          or1.Parameters.Add("MKPSK6", OracleType.NVarChar).Value = dwData["MKPSK6"].ToString(); 
          or1.Parameters.Add("MKPANZM7", OracleType.NVarChar).Value = dwData["MKPANZM7"].ToString(); 
          or1.Parameters.Add("MKPPK7", OracleType.NVarChar).Value = dwData["MKPPK7"].ToString(); 
          or1.Parameters.Add("MKPDI7", OracleType.NVarChar).Value = dwData["MKPDI7"].ToString(); 
          or1.Parameters.Add("MKPTR7", OracleType.NVarChar).Value = dwData["MKPTR7"].ToString(); 
          or1.Parameters.Add("MKPFR7", OracleType.NVarChar).Value = dwData["MKPFR7"].ToString(); 
          or1.Parameters.Add("MKPRU7", OracleType.NVarChar).Value = dwData["MKPRU7"].ToString(); 
          or1.Parameters.Add("MKPSK7", OracleType.NVarChar).Value = dwData["MKPSK7"].ToString(); 
          or1.Parameters.Add("MKPANZM8", OracleType.NVarChar).Value = dwData["MKPANZM8"].ToString(); 
          or1.Parameters.Add("MKPPK8", OracleType.NVarChar).Value = dwData["MKPPK8"].ToString(); 
          or1.Parameters.Add("MKPDI8", OracleType.NVarChar).Value = dwData["MKPDI8"].ToString(); 
          or1.Parameters.Add("MKPTR8", OracleType.NVarChar).Value = dwData["MKPTR8"].ToString(); 
          or1.Parameters.Add("MKPFR8", OracleType.NVarChar).Value = dwData["MKPFR8"].ToString(); 
          or1.Parameters.Add("MKPRU8", OracleType.NVarChar).Value = dwData["MKPRU8"].ToString(); 
          or1.Parameters.Add("MKPSK8", OracleType.NVarChar).Value = dwData["MKPSK8"].ToString(); 
          or1.Parameters.Add("MKPANZM9", OracleType.NVarChar).Value = dwData["MKPANZM9"].ToString(); 
          or1.Parameters.Add("MKPPK9", OracleType.NVarChar).Value = dwData["MKPPK9"].ToString(); 
          or1.Parameters.Add("MKPDI9", OracleType.NVarChar).Value = dwData["MKPDI9"].ToString(); 
          or1.Parameters.Add("MKPTR9", OracleType.NVarChar).Value = dwData["MKPTR9"].ToString(); 
          or1.Parameters.Add("MKPFR9", OracleType.NVarChar).Value = dwData["MKPFR9"].ToString(); 
          or1.Parameters.Add("MKPRU9", OracleType.NVarChar).Value = dwData["MKPRU9"].ToString(); 
          or1.Parameters.Add("MKPSK9", OracleType.NVarChar).Value = dwData["MKPSK9"].ToString(); 
          or1.Parameters.Add("MKPANZM10", OracleType.NVarChar).Value = dwData["MKPANZM10"].ToString(); 
          or1.Parameters.Add("MKPPK10", OracleType.NVarChar).Value = dwData["MKPPK10"].ToString(); 
          or1.Parameters.Add("MKPDI10", OracleType.NVarChar).Value = dwData["MKPDI10"].ToString(); 
          or1.Parameters.Add("MKPTR10", OracleType.NVarChar).Value = dwData["MKPTR10"].ToString(); 
          or1.Parameters.Add("MKPFR10", OracleType.NVarChar).Value = dwData["MKPFR10"].ToString(); 
          or1.Parameters.Add("MKPRU10", OracleType.NVarChar).Value = dwData["MKPRU10"].ToString(); 
          or1.Parameters.Add("MKPSK10", OracleType.NVarChar).Value = dwData["MKPSK10"].ToString(); 
          or1.Parameters.Add("MKPANZM11", OracleType.NVarChar).Value = dwData["MKPANZM11"].ToString(); 
          or1.Parameters.Add("MKPPK11", OracleType.NVarChar).Value = dwData["MKPPK11"].ToString(); 
          or1.Parameters.Add("MKPDI11", OracleType.NVarChar).Value = dwData["MKPDI11"].ToString(); 
          or1.Parameters.Add("MKPTR11", OracleType.NVarChar).Value = dwData["MKPTR11"].ToString(); 
          or1.Parameters.Add("MKPFR11", OracleType.NVarChar).Value = dwData["MKPFR11"].ToString(); 
          or1.Parameters.Add("MKPRU11", OracleType.NVarChar).Value = dwData["MKPRU11"].ToString(); 
          or1.Parameters.Add("MKPSK11", OracleType.NVarChar).Value = dwData["MKPSK11"].ToString(); 
          or1.Parameters.Add("MKPANZM12", OracleType.NVarChar).Value = dwData["MKPANZM12"].ToString(); 
          or1.Parameters.Add("MKPPK12", OracleType.NVarChar).Value = dwData["MKPPK12"].ToString(); 
          or1.Parameters.Add("MKPDI12", OracleType.NVarChar).Value = dwData["MKPDI12"].ToString(); 
          or1.Parameters.Add("MKPTR12", OracleType.NVarChar).Value = dwData["MKPTR12"].ToString(); 
          or1.Parameters.Add("MKPFR12", OracleType.NVarChar).Value = dwData["MKPFR12"].ToString(); 
          or1.Parameters.Add("MKPRU12", OracleType.NVarChar).Value = dwData["MKPRU12"].ToString(); 
          or1.Parameters.Add("MKPSK12", OracleType.NVarChar).Value = dwData["MKPSK12"].ToString(); 
          or1.Parameters.Add("MKPANZM13", OracleType.NVarChar).Value = dwData["MKPANZM13"].ToString(); 
          or1.Parameters.Add("MKPPK13", OracleType.NVarChar).Value = dwData["MKPPK13"].ToString(); 
          or1.Parameters.Add("MKPDI13", OracleType.NVarChar).Value = dwData["MKPDI13"].ToString(); 
          or1.Parameters.Add("MKPTR13", OracleType.NVarChar).Value = dwData["MKPTR13"].ToString(); 
          or1.Parameters.Add("MKPFR13", OracleType.NVarChar).Value = dwData["MKPFR13"].ToString(); 
          or1.Parameters.Add("MKPRU13", OracleType.NVarChar).Value = dwData["MKPRU13"].ToString(); 
          or1.Parameters.Add("MKPSK13", OracleType.NVarChar).Value = dwData["MKPSK13"].ToString(); 
          or1.Parameters.Add("MKPANZM14", OracleType.NVarChar).Value = dwData["MKPANZM14"].ToString(); 
          or1.Parameters.Add("MKPPK14", OracleType.NVarChar).Value = dwData["MKPPK14"].ToString(); 
          or1.Parameters.Add("MKPDI14", OracleType.NVarChar).Value = dwData["MKPDI14"].ToString(); 
          or1.Parameters.Add("MKPTR14", OracleType.NVarChar).Value = dwData["MKPTR14"].ToString(); 
          or1.Parameters.Add("MKPFR14", OracleType.NVarChar).Value = dwData["MKPFR14"].ToString(); 
          or1.Parameters.Add("MKPRU14", OracleType.NVarChar).Value = dwData["MKPRU14"].ToString(); 
          or1.Parameters.Add("MKPSK14", OracleType.NVarChar).Value = dwData["MKPSK14"].ToString(); 
          or1.Parameters.Add("MKPANZM15", OracleType.NVarChar).Value = dwData["MKPANZM15"].ToString(); 
          or1.Parameters.Add("MKPPK15", OracleType.NVarChar).Value = dwData["MKPPK15"].ToString(); 
          or1.Parameters.Add("MKPDI15", OracleType.NVarChar).Value = dwData["MKPDI15"].ToString(); 
          or1.Parameters.Add("MKPTR15", OracleType.NVarChar).Value = dwData["MKPTR15"].ToString(); 
          or1.Parameters.Add("MKPFR15", OracleType.NVarChar).Value = dwData["MKPFR15"].ToString(); 
          or1.Parameters.Add("MKPRU15", OracleType.NVarChar).Value = dwData["MKPRU15"].ToString(); 
          or1.Parameters.Add("MKPSK15", OracleType.NVarChar).Value = dwData["MKPSK15"].ToString(); 
          or1.Parameters.Add("MKPANZM16", OracleType.NVarChar).Value = dwData["MKPANZM16"].ToString(); 
          or1.Parameters.Add("MKPPK16", OracleType.NVarChar).Value = dwData["MKPPK16"].ToString(); 
          or1.Parameters.Add("MKPDI16", OracleType.NVarChar).Value = dwData["MKPDI16"].ToString(); 
          or1.Parameters.Add("MKPTR16", OracleType.NVarChar).Value = dwData["MKPTR16"].ToString(); 
          or1.Parameters.Add("MKPFR16", OracleType.NVarChar).Value = dwData["MKPFR16"].ToString(); 
          or1.Parameters.Add("MKPRU16", OracleType.NVarChar).Value = dwData["MKPRU16"].ToString(); 
          or1.Parameters.Add("MKPSK16", OracleType.NVarChar).Value = dwData["MKPSK16"].ToString(); 
          or1.Parameters.Add("MKPANZM17", OracleType.NVarChar).Value = dwData["MKPANZM17"].ToString(); 
          or1.Parameters.Add("MKPPK17", OracleType.NVarChar).Value = dwData["MKPPK17"].ToString(); 
          or1.Parameters.Add("MKPDI17", OracleType.NVarChar).Value = dwData["MKPDI17"].ToString(); 
          or1.Parameters.Add("MKPTR17", OracleType.NVarChar).Value = dwData["MKPTR17"].ToString(); 
          or1.Parameters.Add("MKPFR17", OracleType.NVarChar).Value = dwData["MKPFR17"].ToString(); 
          or1.Parameters.Add("MKPRU17", OracleType.NVarChar).Value = dwData["MKPRU17"].ToString(); 
          or1.Parameters.Add("MKPSK17", OracleType.NVarChar).Value = dwData["MKPSK17"].ToString(); 
          or1.Parameters.Add("MKPANZM18", OracleType.NVarChar).Value = dwData["MKPANZM18"].ToString(); 
          or1.Parameters.Add("MKPPK18", OracleType.NVarChar).Value = dwData["MKPPK18"].ToString(); 
          or1.Parameters.Add("MKPDI18", OracleType.NVarChar).Value = dwData["MKPDI18"].ToString(); 
          or1.Parameters.Add("MKPTR18", OracleType.NVarChar).Value = dwData["MKPTR18"].ToString(); 
          or1.Parameters.Add("MKPFR18", OracleType.NVarChar).Value = dwData["MKPFR18"].ToString(); 
          or1.Parameters.Add("MKPRU18", OracleType.NVarChar).Value = dwData["MKPRU18"].ToString(); 
          or1.Parameters.Add("MKPSK18", OracleType.NVarChar).Value = dwData["MKPSK18"].ToString(); 
          or1.Parameters.Add("MKPANZM19", OracleType.NVarChar).Value = dwData["MKPANZM19"].ToString(); 
          or1.Parameters.Add("MKPPK19", OracleType.NVarChar).Value = dwData["MKPPK19"].ToString(); 
          or1.Parameters.Add("MKPDI19", OracleType.NVarChar).Value = dwData["MKPDI19"].ToString(); 
          or1.Parameters.Add("MKPTR19", OracleType.NVarChar).Value = dwData["MKPTR19"].ToString(); 
          or1.Parameters.Add("MKPFR19", OracleType.NVarChar).Value = dwData["MKPFR19"].ToString(); 
          or1.Parameters.Add("MKPRU19", OracleType.NVarChar).Value = dwData["MKPRU19"].ToString(); 
          or1.Parameters.Add("MKPSK19", OracleType.NVarChar).Value = dwData["MKPSK19"].ToString(); 
          or1.Parameters.Add("MKPANZM20", OracleType.NVarChar).Value = dwData["MKPANZM20"].ToString(); 
          or1.Parameters.Add("MKPPK20", OracleType.NVarChar).Value = dwData["MKPPK20"].ToString(); 
          or1.Parameters.Add("MKPDI20", OracleType.NVarChar).Value = dwData["MKPDI20"].ToString(); 
          or1.Parameters.Add("MKPTR20", OracleType.NVarChar).Value = dwData["MKPTR20"].ToString(); 
          or1.Parameters.Add("MKPFR20", OracleType.NVarChar).Value = dwData["MKPFR20"].ToString(); 
          or1.Parameters.Add("MKPRU20", OracleType.NVarChar).Value = dwData["MKPRU20"].ToString(); 
          or1.Parameters.Add("MKPSK20", OracleType.NVarChar).Value = dwData["MKPSK20"].ToString(); 
          or1.Parameters.Add("MKPANZM21", OracleType.NVarChar).Value = dwData["MKPANZM21"].ToString(); 
          or1.Parameters.Add("MKPPK21", OracleType.NVarChar).Value = dwData["MKPPK21"].ToString(); 
          or1.Parameters.Add("MKPDI21", OracleType.NVarChar).Value = dwData["MKPDI21"].ToString(); 
          or1.Parameters.Add("MKPTR21", OracleType.NVarChar).Value = dwData["MKPTR21"].ToString(); 
          or1.Parameters.Add("MKPFR21", OracleType.NVarChar).Value = dwData["MKPFR21"].ToString(); 
          or1.Parameters.Add("MKPRU21", OracleType.NVarChar).Value = dwData["MKPRU21"].ToString(); 
          or1.Parameters.Add("MKPSK21", OracleType.NVarChar).Value = dwData["MKPSK21"].ToString(); 
          or1.Parameters.Add("MKPANZM22", OracleType.NVarChar).Value = dwData["MKPANZM22"].ToString(); 
          or1.Parameters.Add("MKPPK22", OracleType.NVarChar).Value = dwData["MKPPK22"].ToString(); 
          or1.Parameters.Add("MKPDI22", OracleType.NVarChar).Value = dwData["MKPDI22"].ToString(); 
          or1.Parameters.Add("MKPTR22", OracleType.NVarChar).Value = dwData["MKPTR22"].ToString(); 
          or1.Parameters.Add("MKPFR22", OracleType.NVarChar).Value = dwData["MKPFR22"].ToString(); 
          or1.Parameters.Add("MKPRU22", OracleType.NVarChar).Value = dwData["MKPRU22"].ToString(); 
          or1.Parameters.Add("MKPSK22", OracleType.NVarChar).Value = dwData["MKPSK22"].ToString(); 
          or1.Parameters.Add("MKPANZM23", OracleType.NVarChar).Value = dwData["MKPANZM23"].ToString(); 
          or1.Parameters.Add("MKPPK23", OracleType.NVarChar).Value = dwData["MKPPK23"].ToString(); 
          or1.Parameters.Add("MKPDI23", OracleType.NVarChar).Value = dwData["MKPDI23"].ToString(); 
          or1.Parameters.Add("MKPTR23", OracleType.NVarChar).Value = dwData["MKPTR23"].ToString(); 
          or1.Parameters.Add("MKPFR23", OracleType.NVarChar).Value = dwData["MKPFR23"].ToString(); 
          or1.Parameters.Add("MKPRU23", OracleType.NVarChar).Value = dwData["MKPRU23"].ToString(); 
          or1.Parameters.Add("MKPSK23", OracleType.NVarChar).Value = dwData["MKPSK23"].ToString(); 
          or1.Parameters.Add("MKPANZM24", OracleType.NVarChar).Value = dwData["MKPANZM24"].ToString(); 
          or1.Parameters.Add("MKPPK24", OracleType.NVarChar).Value = dwData["MKPPK24"].ToString(); 
          or1.Parameters.Add("MKPDI24", OracleType.NVarChar).Value = dwData["MKPDI24"].ToString(); 
          or1.Parameters.Add("MKPTR24", OracleType.NVarChar).Value = dwData["MKPTR24"].ToString(); 
          or1.Parameters.Add("MKPFR24", OracleType.NVarChar).Value = dwData["MKPFR24"].ToString(); 
          or1.Parameters.Add("MKPRU24", OracleType.NVarChar).Value = dwData["MKPRU24"].ToString(); 
          or1.Parameters.Add("MKPSK24", OracleType.NVarChar).Value = dwData["MKPSK24"].ToString(); 
          or1.Parameters.Add("MKPANZM25", OracleType.NVarChar).Value = dwData["MKPANZM25"].ToString(); 
          or1.Parameters.Add("MKPPK25", OracleType.NVarChar).Value = dwData["MKPPK25"].ToString(); 
          or1.Parameters.Add("MKPDI25", OracleType.NVarChar).Value = dwData["MKPDI25"].ToString(); 
          or1.Parameters.Add("MKPTR25", OracleType.NVarChar).Value = dwData["MKPTR25"].ToString(); 
          or1.Parameters.Add("MKPFR25", OracleType.NVarChar).Value = dwData["MKPFR25"].ToString(); 
          or1.Parameters.Add("MKPRU25", OracleType.NVarChar).Value = dwData["MKPRU25"].ToString(); 
          or1.Parameters.Add("MKPSK25", OracleType.NVarChar).Value = dwData["MKPSK25"].ToString(); 
          or1.Parameters.Add("MKPANZM26", OracleType.NVarChar).Value = dwData["MKPANZM26"].ToString(); 
          or1.Parameters.Add("MKPPK26", OracleType.NVarChar).Value = dwData["MKPPK26"].ToString(); 
          or1.Parameters.Add("MKPDI26", OracleType.NVarChar).Value = dwData["MKPDI26"].ToString(); 
          or1.Parameters.Add("MKPTR26", OracleType.NVarChar).Value = dwData["MKPTR26"].ToString(); 
          or1.Parameters.Add("MKPFR26", OracleType.NVarChar).Value = dwData["MKPFR26"].ToString(); 
          or1.Parameters.Add("MKPRU26", OracleType.NVarChar).Value = dwData["MKPRU26"].ToString(); 
          or1.Parameters.Add("MKPSK26", OracleType.NVarChar).Value = dwData["MKPSK26"].ToString(); 
          or1.Parameters.Add("MKPANZM27", OracleType.NVarChar).Value = dwData["MKPANZM27"].ToString(); 
          or1.Parameters.Add("MKPPK27", OracleType.NVarChar).Value = dwData["MKPPK27"].ToString(); 
          or1.Parameters.Add("MKPDI27", OracleType.NVarChar).Value = dwData["MKPDI27"].ToString(); 
          or1.Parameters.Add("MKPTR27", OracleType.NVarChar).Value = dwData["MKPTR27"].ToString(); 
          or1.Parameters.Add("MKPFR27", OracleType.NVarChar).Value = dwData["MKPFR27"].ToString(); 
          or1.Parameters.Add("MKPRU27", OracleType.NVarChar).Value = dwData["MKPRU27"].ToString(); 
          or1.Parameters.Add("MKPSK27", OracleType.NVarChar).Value = dwData["MKPSK27"].ToString(); 
          or1.Parameters.Add("MKPANZM28", OracleType.NVarChar).Value = dwData["MKPANZM28"].ToString(); 
          or1.Parameters.Add("MKPPK28", OracleType.NVarChar).Value = dwData["MKPPK28"].ToString(); 
          or1.Parameters.Add("MKPDI28", OracleType.NVarChar).Value = dwData["MKPDI28"].ToString(); 
          or1.Parameters.Add("MKPTR28", OracleType.NVarChar).Value = dwData["MKPTR28"].ToString(); 
          or1.Parameters.Add("MKPFR28", OracleType.NVarChar).Value = dwData["MKPFR28"].ToString(); 
          or1.Parameters.Add("MKPRU28", OracleType.NVarChar).Value = dwData["MKPRU28"].ToString(); 
          or1.Parameters.Add("MKPSK28", OracleType.NVarChar).Value = dwData["MKPSK28"].ToString(); 
          or1.Parameters.Add("MKPANZM29", OracleType.NVarChar).Value = dwData["MKPANZM29"].ToString(); 
          or1.Parameters.Add("MKPPK29", OracleType.NVarChar).Value = dwData["MKPPK29"].ToString(); 
          or1.Parameters.Add("MKPDI29", OracleType.NVarChar).Value = dwData["MKPDI29"].ToString(); 
          or1.Parameters.Add("MKPTR29", OracleType.NVarChar).Value = dwData["MKPTR29"].ToString(); 
          or1.Parameters.Add("MKPFR29", OracleType.NVarChar).Value = dwData["MKPFR29"].ToString(); 
          or1.Parameters.Add("MKPRU29", OracleType.NVarChar).Value = dwData["MKPRU29"].ToString(); 
          or1.Parameters.Add("MKPSK29", OracleType.NVarChar).Value = dwData["MKPSK29"].ToString(); 
          or1.Parameters.Add("MKPANZM30", OracleType.NVarChar).Value = dwData["MKPANZM30"].ToString(); 
          or1.Parameters.Add("MKPPK30", OracleType.NVarChar).Value = dwData["MKPPK30"].ToString(); 
          or1.Parameters.Add("MKPDI30", OracleType.NVarChar).Value = dwData["MKPDI30"].ToString(); 
          or1.Parameters.Add("MKPTR30", OracleType.NVarChar).Value = dwData["MKPTR30"].ToString(); 
          or1.Parameters.Add("MKPFR30", OracleType.NVarChar).Value = dwData["MKPFR30"].ToString(); 
          or1.Parameters.Add("MKPRU30", OracleType.NVarChar).Value = dwData["MKPRU30"].ToString(); 
          or1.Parameters.Add("MKPSK30", OracleType.NVarChar).Value = dwData["MKPSK30"].ToString(); 
          or1.Parameters.Add("MKPANZM31", OracleType.NVarChar).Value = dwData["MKPANZM31"].ToString(); 
          or1.Parameters.Add("MKPPK31", OracleType.NVarChar).Value = dwData["MKPPK31"].ToString(); 
          or1.Parameters.Add("MKPDI31", OracleType.NVarChar).Value = dwData["MKPDI31"].ToString(); 
          or1.Parameters.Add("MKPTR31", OracleType.NVarChar).Value = dwData["MKPTR31"].ToString(); 
          or1.Parameters.Add("MKPFR31", OracleType.NVarChar).Value = dwData["MKPFR31"].ToString(); 
          or1.Parameters.Add("MKPRU31", OracleType.NVarChar).Value = dwData["MKPRU31"].ToString(); 
          or1.Parameters.Add("MKPSK31", OracleType.NVarChar).Value = dwData["MKPSK31"].ToString(); 
          or1.Parameters.Add("MKPFAKTOR", OracleType.NVarChar).Value = dwData["MKPFAKTOR"].ToString(); 
          or1.Parameters.Add("MKPANZTAG", OracleType.NVarChar).Value = dwData["MKPANZTAG"].ToString(); 
          or1.Parameters.Add("MKPFILLER", OracleType.NVarChar).Value = dwData["MKPFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
